package com.system.provider;

import com.am.ui.grid.AbstractBaseGridProvider;
import com.system.uitls.SearchFilter;
import java.util.Map;

public class DrugCheckHistoryListProvider extends AbstractBaseGridProvider
{
  public String generateSql(Map<String, Object> map)
  {
    StringBuffer sql = new StringBuffer("SELECT t1.id,t1.user_name,t1.place,t1.campus,t1.create_time,t1.notes,t2.approve_result FROM sys_out_storage t1,sys_approve t2 WHERE t1.id = t2.out_storage_id AND t2.type = '4' AND t1.place = :place ");

    sql.append(SearchFilter.getSearchSql(map, "t1"));
    setParamMap(map);
    return sql.toString();
  }
}